SQL DELETE Examples 1-4

-- Example 1. Drop S1020's student record.
DELETE
FROM		Student
WHERE	StuId = 'S1020';


-- Example 2. Drop all the enrollment records for S1020
DELETE
FROM		Enroll
WHERE 	StuId = 'S1020';

-- Example 3. Drop all class records.
DELETE
FROM		Class;


-- Example 4. Drop all enrollment records for Owen Mc Carthy.
DELETE	FROM		Enroll
WHERE	StuId =		(SELECT	StuId
			FROM	Student
			WHERE 	lastName = Mc Carthy' AND firstName = Owen); 